Agent Central Host Computer/Agent - Central Host Computer.iso/_SETUP.1/vsumcscurcnt.sql

Text File | 2000-05-12 | 406b | 14 lines

/*
This view sums the cscurcnt data for a particular conversion segment.
*/
create or replace view vsumcscurcnt as
select vcurstaterange.conversion_num,
    vcurstaterange.close_count,
    vcurstaterange.cashbox_glid,
    sum(cscurcnt.reset_value ) totalcash
from vcurstaterange, cscurcnt
where cscurcnt.det_seq_num = close_count
group by conversion_num,  close_count,vcurstaterange.cashbox_glid;